﻿CREATE PROCEDURE dbo.SP_MemberAddresses_UPDATE
												@AddressId Int 							  =  NULL 
														, @AppartmentNumber NChar 							(10)  =  NULL 
														, @BuildingNumber NChar 							(10)  =  NULL 
														, @Directions NVarChar (Max)							  =  NULL 
														, @FloorNumber NChar 							(10)  =  NULL 
														, @MemberId Int 							  =  NULL 
														, @Street NVarChar 							(256)  =  NULL 
														, @ZipCode NChar 							(10)  =  NULL 
												AS
					UPDATE MemberAddresses SET
													AppartmentNumber=@AppartmentNumber 
																,BuildingNumber=@BuildingNumber
																,Directions=@Directions
																,FloorNumber=@FloorNumber
																,MemberId=@MemberId
																,Street=@Street
																,ZipCode=@ZipCode
													Where 	
												AddressId=@AddressId
							